# -*- coding: utf-8 -*-
"""
Created on Thu Apr 23 09:12:09 2020

@author: 付说举于版筑之间
"""

import pandas as pd

import matplotlib.pyplot as plt
'''
df = pd.read_csv("dataS.csv")
df=df.rename(columns={"车数：12":"12 cars", "车数：15":"15 cars", "车数：18": "18 cars"})

#boxplot=dT.boxplot()
df.to_csv("dfSteps.csv",index=False)
print(df)
'''

t6emp = pd.read_csv("astarT6emp.csv")
t6random=pd.read_csv("astarT6random.csv")


'''
df1=pd.read_csv("maxT.csv",index_col=0,names=["Scale of Vehicle Platoon","Max Time"])
df2=pd.read_csv("sampleT.csv",index_col=0,names=["Scale of Vehicle Platoon","Median Time"])
df3=pd.read_csv("varT.csv",index_col=0,names=["Scale of Vehicle Platoon","Var of Time"])
#df4=pd.read_csv("minT.csv",index_col=0,names=["Number of Cars","Min Time"])
#df5=pd.read_csv("meanS.csv",index_col=0,names=["Number of Cars","Average Steps"])
'''
#df3=pd.DataFrame(df2,)
frames = [t6random,t6emp]
result = pd.concat(frames,axis=1, sort=False)
result.to_csv("empbetter.csv")

result.plot()
plt.legend(labels=["Fisrt row occupied","Fisrt row empty"])
plt.ylabel("Time Consuming(s)")
plt.xlabel("Number of Random Seed")
plt.show()